Overview

The Supply Chain module in CRYSTALL BALL is designed to give businesses complete visibility into demand and stock requirements. By combining expected sales forecasts with real-time inventory data, the module helps companies plan procurement, avoid shortages, and ensure timely product availability.

Purpose

• Transform sales forecasts into actionable supply requirements.
• Provide clarity on future stock positions and demand coverage.
• Enable automated procurement by generating purchase requests when gaps are detected.

Key Features

1. Expected Sales

   • Record and classify forecasts as Rolling, Committed, or Annual.
   • Define planning periods by fiscal year, start and end dates, and months.
   • Capture product-level expected quantities through the Capacity Plan table.

2. Expected Sales Forecast Report

   • Consolidates sales data into weekly, monthly, and annual views.
   • Prioritizes committed values, then rolling, then annual forecasts.
   • Includes filters for Fiscal Year, Start Date, and End Date.

3. Adjusting Stock Projected Qty Report

   • Calculates future stock levels using available, ordered, and reserved quantities.
   • Compares actual safety stock with forecasted demand to identify shortages.
   • Provides direct action by allowing Material Requests to be created with one click.

Business Value

• Ensures accurate procurement planning based on real forecasts.
• Reduces the risk of stockouts by proactively identifying shortages.
• Optimizes inventory management, balancing between safety stock and over-purchasing.
• Supports strategic supply chain decisions through integrated forecasting and stock visibility.